// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_PICKING_MATERIAL
// * CreateDate    : 2012/4/11 22:32:25
// * Creater       : CodeSmith
// * LastChangeDate: 2012/4/11 22:32:25
// * LastChanger   : 2012/4/11 22:32:25
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class ProdPickingMaterialTable : TableInfo
    {
        public const string C_TableName = "PROD_PICKING_MATERIAL";

        public const string C_PICKING_MATERIAL_ID = "PICKING_MATERIAL_ID";
        public const string C_PLAN_ORDER_ID = "PLAN_ORDER_ID";
        public const string C_PICKING_CODE = "PICKING_CODE";
        public const string C_PICKING_TYPE = "PICKING_TYPE";
        public const string C_PICKING_DEPARTMENT = "PICKING_DEPARTMENT";
        public const string C_WAREHOUSE_CODE = "WAREHOUSE_CODE";
        public const string C_PICKING_PERSON = "PICKING_PERSON";
        public const string C_REMARK = "REMARK";
        public const string C_CREATED_DATE = "CREATED_DATE";
        public const string C_CREATED_BY = "CREATED_BY";
        public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
        public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
        public const string C_APPROVED_DATE = "APPROVED_DATE";
        public const string C_APPROVED_BY = "APPROVED_BY";
        public const string C_STATUS = "STATUS";
        public const string C_PLAN_DELIVERY_DATE = "PLAN_DELIVERY_DATE";
        public const string C_PRINT_STATUS = "PRINT_STATUS";

        public ProdPickingMaterialTable()
        {
            _tableName = "PROD_PICKING_MATERIAL";
        }

        protected static ProdPickingMaterialTable _current;
        public static ProdPickingMaterialTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new ProdPickingMaterialTable();

            _current.Add(C_PICKING_MATERIAL_ID, new ColumnInfo(C_PICKING_MATERIAL_ID, "PickingMaterialId", true, typeof(string)));
            _current.Add(C_PLAN_ORDER_ID, new ColumnInfo(C_PLAN_ORDER_ID, "PlanOrderId", false, typeof(string)));
            _current.Add(C_PICKING_CODE, new ColumnInfo(C_PICKING_CODE, "PickingCode", false, typeof(string)));
            _current.Add(C_PICKING_TYPE, new ColumnInfo(C_PICKING_TYPE, "PickingType", false, typeof(string)));
            _current.Add(C_PICKING_DEPARTMENT, new ColumnInfo(C_PICKING_DEPARTMENT, "PickingDepartment", false, typeof(string)));
            _current.Add(C_WAREHOUSE_CODE, new ColumnInfo(C_WAREHOUSE_CODE, "WarehouseCode", false, typeof(string)));
            _current.Add(C_PICKING_PERSON, new ColumnInfo(C_PICKING_PERSON, "PickingPerson", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE, "CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY, "CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE, "LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY, "LastModifiedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE, "ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY, "ApprovedBy", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_PLAN_DELIVERY_DATE, new ColumnInfo(C_PLAN_DELIVERY_DATE, "PlanDeliveryDate", false, typeof(DateTime)));
            _current.Add(C_PRINT_STATUS, new ColumnInfo(C_PRINT_STATUS, "PrintStatus", false, typeof(int)));

        }

        public ColumnInfo PICKING_MATERIAL_ID
        {
            get { return this[C_PICKING_MATERIAL_ID]; }
        }

        public ColumnInfo PLAN_ORDER_ID
        {
            get { return this[C_PLAN_ORDER_ID]; }
        }

        public ColumnInfo PICKING_CODE
        {
            get { return this[C_PICKING_CODE]; }
        }

        public ColumnInfo PICKING_TYPE
        {
            get { return this[C_PICKING_TYPE]; }
        }

        public ColumnInfo PICKING_DEPARTMENT
        {
            get { return this[C_PICKING_DEPARTMENT]; }
        }

        public ColumnInfo WAREHOUSE_CODE
        {
            get { return this[C_WAREHOUSE_CODE]; }
        }

        public ColumnInfo PICKING_PERSON
        {
            get { return this[C_PICKING_PERSON]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }

        public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }

        public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }

        public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }

        public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }

        public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }

        public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo PLAN_DELIVERY_DATE
        {
            get { return this[C_PLAN_DELIVERY_DATE]; }
        }

        public ColumnInfo PRINT_STATUS
        {
            get { return this[C_PRINT_STATUS]; }
        }



    }
}

